
if exists(select name from sysobjects where name = 'sp_DiemGetTBHocKy')
	drop proc sp_DiemGetTBHocKy
go
/*
	Created by: Phuoc NH
	Created on: 13/05/2013 (dd/mm/yyyy)
	Description: 
	--

	File:$sql-scripts/Proc.sp_DiemGetTBHocKy.sql
*/

create proc sp_DiemGetTBHocKy
@MaSinhVien varchar(50),
@Nam varchar(4),
@HocKy varchar(3) 
as
begin
	select * from v_BangDiemTBHK where MaSinhVien=@MaSinhVien and SUBSTRING(KyNamHoc, 1, 4)=@Nam and SUBSTRING(KyNamHoc, 11,3)=@HocKy
end


